{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1. Flock Entry","2. Basic calculator","3. DDD DCD","4. Instructions","Sheet 5"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":18,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Flock Entry","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Number"]
["Ewes on farm",100]
["Lambs (store or for breeding)",2]
["Lambs finished",1]
[]
[]
["Total kg",{"$f":"(A15*B2)+(A16*B3)+(B4*A16)","v":7560}]
[]
[]
[]
[]
[]
[]
["Weight (Kg)"]
[75]
[20]

{"sheet":"2. Basic calculator","index":1,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"TOTAL","Critical"]
[null,null,"Total mg/kg",null,{"$f":"(SUM(E7:E57))","v":1.984126984126984E-2},{"$f":"SUM(J30:J35)","v":0}]
[null,null,"Total DDD",null,{"$f":"'3. DDD DCD'!H8","v":2.3905144387072093E-3},{"$f":"'3. DDD DCD'!I8","v":0}]
[null,null,"Total DCD",null,{"$f":"'3. DDD DCD'!J8","v":6.8418171866447728E-4},{"$f":"'3. DDD DCD'!K8","v":0}]
[]
["Route","Product","Amount used","Units","mg/kg","Critically important?"]
["Injectable","Clamoxyl Ready-to-Use 150 mg/ml suspension for injection",1,{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,All,9,FALSE))","v":"ml"},{"$f":"IF(B7=\"\",\"\",(C7*(VLOOKUP(B7,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":1.984126984126984E-2},{"$f":"IF(B7=\"\",\"\",IF((VLOOKUP(B7,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(B8=\"\",\"\",(C8*(VLOOKUP(B8,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},{"$f":"IF(B8=\"\",\"\",IF((VLOOKUP(B8,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""}]
[null,null,null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,All,9,FALSE))","v":""},{"$f":"IF(B9=\"\",\"\",(C9*(VLOOKUP(B9,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},{"$f":"IF(B9=\"\",\"\",IF((VLOOKUP(B9,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(B10=\"\",\"\",(C10*(VLOOKUP(B10,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B11=\"\",\"\",(C11*(VLOOKUP(B11,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B12=\"\",\"\",(C12*(VLOOKUP(B12,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B13=\"\",\"\",(C13*(VLOOKUP(B13,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B14=\"\",\"\",(C14*(VLOOKUP(B14,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B15=\"\",\"\",(C15*(VLOOKUP(B15,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B16=\"\",\"\",(C16*(VLOOKUP(B16,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B17=\"\",\"\",(C17*(VLOOKUP(B17,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B18=\"\",\"\",(C18*(VLOOKUP(B18,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B19=\"\",\"\",(C19*(VLOOKUP(B19,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B20=\"\",\"\",(C20*(VLOOKUP(B20,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B21=\"\",\"\",(C21*(VLOOKUP(B21,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B22=\"\",\"\",(C22*(VLOOKUP(B22,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B23=\"\",\"\",(C23*(VLOOKUP(B23,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B24=\"\",\"\",(C24*(VLOOKUP(B24,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B25=\"\",\"\",(C25*(VLOOKUP(B25,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B26=\"\",\"\",(C26*(VLOOKUP(B26,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B27=\"\",\"\",(C27*(VLOOKUP(B27,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B28=\"\",\"\",(C28*(VLOOKUP(B28,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B29=\"\",\"\",(C29*(VLOOKUP(B29,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},"",null,null,null,"Critically important"]
[null,null,null,"",{"$f":"IF(B30=\"\",\"\",(C30*(VLOOKUP(B30,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},"","Injectable","Injectable",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G30)","v":1.984126984126984E-2},{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"CRITICAL\",$A$7:$A$57,$G30)","v":0}]
[null,null,null,"",{"$f":"IF(B31=\"\",\"\",(C31*(VLOOKUP(B31,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},"","Oral","Oral",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G31)","v":0},{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"CRITICAL\",$A$7:$A$57,$G31)","v":0}]
[null,null,null,"",{"$f":"IF(B32=\"\",\"\",(C32*(VLOOKUP(B32,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},"","Topical","Topical",0,0]
[null,null,null,"",{"$f":"IF(B33=\"\",\"\",(C33*(VLOOKUP(B33,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},"","Footbath","Footbath",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G33)","v":0},{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"CRITICAL\",$A$7:$A$57,$G33)","v":0}]
[null,null,null,"",{"$f":"IF(B34=\"\",\"\",(C34*(VLOOKUP(B34,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},"","EyeTreatment","Eye",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G34)","v":0},0]
[null,null,null,"",{"$f":"IF(B35=\"\",\"\",(C35*(VLOOKUP(B35,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},"","Intramammary","Intramammary",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G35)","v":0},0]
[null,null,null,"",{"$f":"IF(B36=\"\",\"\",(C36*(VLOOKUP(B36,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B37=\"\",\"\",(C37*(VLOOKUP(B37,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B38=\"\",\"\",(C38*(VLOOKUP(B38,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B39=\"\",\"\",(C39*(VLOOKUP(B39,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B40=\"\",\"\",(C40*(VLOOKUP(B40,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B41=\"\",\"\",(C41*(VLOOKUP(B41,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B42=\"\",\"\",(C42*(VLOOKUP(B42,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B43=\"\",\"\",(C43*(VLOOKUP(B43,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B44=\"\",\"\",(C44*(VLOOKUP(B44,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B45=\"\",\"\",(C45*(VLOOKUP(B45,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B46=\"\",\"\",(C46*(VLOOKUP(B46,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B47=\"\",\"\",(C47*(VLOOKUP(B47,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B48=\"\",\"\",(C48*(VLOOKUP(B48,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B49=\"\",\"\",(C49*(VLOOKUP(B49,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B50=\"\",\"\",(C50*(VLOOKUP(B50,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B51=\"\",\"\",(C51*(VLOOKUP(B51,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B52=\"\",\"\",(C52*(VLOOKUP(B52,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B53=\"\",\"\",(C53*(VLOOKUP(B53,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B54=\"\",\"\",(C54*(VLOOKUP(B54,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B55=\"\",\"\",(C55*(VLOOKUP(B55,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B56=\"\",\"\",(C56*(VLOOKUP(B56,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B57=\"\",\"\",(C57*(VLOOKUP(B57,All,8,FALSE))/('1. Flock Entry'!$B$7)))","v":""},""]

{"sheet":"3. DDD DCD","index":2,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[[7,4,7,6],[5,4,5,6],[4,4,4,6],[3,4,3,6],[9,6,9,8],[6,4,6,6],[28,1,28,2],[27,1,27,2],[26,1,26,2],[11,6,11,8],[10,6,10,8],[34,1,34,2],[35,1,35,2],[36,1,36,2],[13,1,13,2],[14,1,14,2],[21,1,21,2],[20,1,20,2],[19,1,19,2],[18,1,18,2],[17,1,17,2],[16,1,16,2],[15,1,15,2],[25,1,25,2],[24,1,24,2],[23,1,23,2],[22,1,22,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[60,1,60,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2]]}
[null,null,null,null,null,null,null,"DDD","DDDcritical","DCD","DCDcritical"]
[null,null,null,null,"Injectable per kg",null,null,{"$f":"C71","v":2.3905144387072093E-3},{"$f":"E71","v":0},{"$f":"G71","v":6.8418171866447728E-4},{"$f":"I71","v":0}]
[null,null,null,null,"Oral per kg",null,null,{"$f":"D72","v":0},{"$f":"E72","v":0},{"$f":"H72","v":0},0]
[null,null,null,null,"Topical per ewe",null,null,"NA","NA",{"$f":"H73","v":0},0]
[null,null,null,null,"Footbath per ewe",null,null,{"$f":"D74","v":0},{"$f":"E74","v":0},{"$f":"H74","v":0},0]
[null,null,null,null,"Eye treatment per ewe",null,null,{"$f":"C75","v":0},{"$f":"E75","v":0},{"$f":"G75","v":0},0]
[null,null,null,null,"Intramammary per ewe",null,null,{"$f":"C76","v":0},{"$f":"E76","v":0},{"$f":"G76","v":0},0]
[null,null,null,null,"TOTAL",null,null,{"$f":"H2+H3+H6+H5+H7","v":2.3905144387072093E-3},{"$f":"SUM(I2:I3,I5:I7)","v":0},{"$f":"SUM(J2:J7)","v":6.8418171866447728E-4},{"$f":"SUM(K2:K7)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total","Critical"]
[null,null,null,null,null,null,"Total mg/kg in flock",null,null,{"$f":"(SUM(G15:G65))","v":1.984126984126984E-2},{"$f":"SUM(D79:D84)","v":0}]
[null,null,null,null,null,null,"Total DDD",null,null,{"$f":"H8","v":2.3905144387072093E-3},{"$f":"I8","v":0}]
[]
["Route","Product",null,"Amount used","Units","mg","mg/kg","DDDvet","DCDvet","Per","Critically important?",null,null,null,null,null,"DDDvet","DCDvet","per"]
[{"$f":"IF('2. Basic calculator'!A7=\"\",\"\",'2. Basic calculator'!A7)","v":"Injectable"},{"$f":"IF('2. Basic calculator'!B7=\"\",\"\",'2. Basic calculator'!B7)","v":"Clamoxyl Ready-to-Use 150 mg/ml suspension for injection"},null,{"$f":"IF('2. Basic calculator'!C7=\"\",\"\",'2. Basic calculator'!C7)","v":1},{"$f":"IF('2. Basic calculator'!D7=\"\",\"\",'2. Basic calculator'!D7)","v":"ml"},{"$f":"IF(B15=\"\",\"\",D15*VLOOKUP(B15,All,8,FALSE))","v":150},{"$f":"IF('2. Basic calculator'!E7=\"\",\"\",'2. Basic calculator'!E7)","v":1.984126984126984E-2},{"$f":"IF(A15=\"\",\"\",IF(A15=\"Footbath\",F15/Q15/Herdentry2,IF(E15=\"Tubes\",D15/Q15/Herdentry2,IF(E15=\"Units\",F15/Q15/Herdentry2,'3. DDD DCD'!G15/'3. DDD DCD'!Q15))))","v":2.3905144387072093E-3},{"$f":"IF(A15=\"\",\"\",IF(A15=\"Footbath\",F15/R15/Herdentry2,IF(E15=\"Tubes\",D15/R15/Herdentry2,IF(E15=\"Units\",F15/R15/Herdentry2,'3. DDD DCD'!G15/'3. DDD DCD'!R15))))","v":6.8418171866447728E-4},{"$f":"IF(A15=\"\",\"\",IF(A15=\"Footbath\",\"Ewe\",IF(S15=\"kg\",\"kg\",IF(A15=\"Topical\",\"Ewe\",IF(A15=\"EyeTreatment\",\"Ewe\",IF(E15=\"Tubes\",\"Ewe\",\" \"))))))","v":"kg"},{"$f":"IF(B15=\"\",\"\",IF((VLOOKUP(B15,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(B15,All,10,FALSE))","v":8.3000000000000007},{"$f":"IF(A15=\"\",\"\",VLOOKUP(B15,All,11,FALSE))","v":29},{"$f":"IF(E15=\"\",\"\",IF(E15=\"ml\",\"kg\",IF(E15=\"grams\",\"kg\",\"unit\")))","v":"kg"}]
[{"$f":"IF('2. Basic calculator'!A8=\"\",\"\",'2. Basic calculator'!A8)","v":""},{"$f":"IF('2. Basic calculator'!B8=\"\",\"\",'2. Basic calculator'!B8)","v":""},null,{"$f":"IF('2. Basic calculator'!C8=\"\",\"\",'2. Basic calculator'!C8)","v":""},{"$f":"IF('2. Basic calculator'!D8=\"\",\"\",'2. Basic calculator'!D8)","v":""},{"$f":"IF(B16=\"\",\"\",D16*VLOOKUP(B16,All,8,FALSE))","v":""},{"$f":"IF('2. Basic calculator'!E8=\"\",\"\",'2. Basic calculator'!E8)","v":""},{"$f":"IF(A16=\"\",\"\",IF(A16=\"Footbath\",F16/Q16/Herdentry2,IF(E16=\"Tubes\",D16/Q16/Herdentry2,IF(E16=\"Units\",F16/Q16/Herdentry2,'3. DDD DCD'!G16/'3. DDD DCD'!Q16))))","v":""},{"$f":"IF(A16=\"\",\"\",IF(A16=\"Footbath\",F16/R16/Herdentry2,IF(E16=\"Tubes\",D16/R16/Herdentry2,IF(E16=\"Units\",F16/R16/Herdentry2,'3. DDD DCD'!G16/'3. DDD DCD'!R16))))","v":""},{"$f":"IF(A16=\"\",\"\",IF(A16=\"Footbath\",\"Ewe\",IF(S16=\"kg\",\"kg\",IF(A16=\"Topical\",\"Ewe\",IF(A16=\"EyeTreatment\",\"Ewe\",IF(E16=\"Tubes\",\"Ewe\",\" \"))))))","v":""},"",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A9=\"\",\"\",'2. Basic calculator'!A9)","v":""},{"$f":"IF('2. Basic calculator'!B9=\"\",\"\",'2. Basic calculator'!B9)","v":""},null,{"$f":"IF('2. Basic calculator'!C9=\"\",\"\",'2. Basic calculator'!C9)","v":""},{"$f":"IF('2. Basic calculator'!D9=\"\",\"\",'2. Basic calculator'!D9)","v":""},"",{"$f":"IF('2. Basic calculator'!E9=\"\",\"\",'2. Basic calculator'!E9)","v":""},{"$f":"IF(A17=\"\",\"\",IF(A17=\"Footbath\",F17/Q17/Herdentry2,IF(E17=\"Tubes\",D17/Q17/Herdentry2,IF(E17=\"Units\",F17/Q17/Herdentry2,'3. DDD DCD'!G17/'3. DDD DCD'!Q17))))","v":""},{"$f":"IF(A17=\"\",\"\",IF(A17=\"Footbath\",F17/R17/Herdentry2,IF(E17=\"Tubes\",D17/R17/Herdentry2,IF(E17=\"Units\",F17/R17/Herdentry2,'3. DDD DCD'!G17/'3. DDD DCD'!R17))))","v":""},"","",null,null,null,null,null,"","",{"$f":"IF(E17=\"\",\"\",IF(E17=\"ml\",\"kg\",IF(E17=\"grams\",\"kg\",\"unit\")))","v":""}]
[{"$f":"IF('2. Basic calculator'!A10=\"\",\"\",'2. Basic calculator'!A10)","v":""},{"$f":"IF('2. Basic calculator'!B10=\"\",\"\",'2. Basic calculator'!B10)","v":""},null,{"$f":"IF('2. Basic calculator'!C10=\"\",\"\",'2. Basic calculator'!C10)","v":""},{"$f":"IF('2. Basic calculator'!D10=\"\",\"\",'2. Basic calculator'!D10)","v":""},"",{"$f":"IF('2. Basic calculator'!E10=\"\",\"\",'2. Basic calculator'!E10)","v":""},{"$f":"IF(A18=\"\",\"\",IF(A18=\"Footbath\",F18/Q18/Herdentry2,IF(E18=\"Tubes\",D18/Q18/Herdentry2,IF(E18=\"Units\",F18/Q18/Herdentry2,'3. DDD DCD'!G18/'3. DDD DCD'!Q18))))","v":""},{"$f":"IF(A18=\"\",\"\",IF(A18=\"Footbath\",F18/R18/Herdentry2,IF(E18=\"Tubes\",D18/R18/Herdentry2,IF(E18=\"Units\",F18/R18/Herdentry2,'3. DDD DCD'!G18/'3. DDD DCD'!R18))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A11=\"\",\"\",'2. Basic calculator'!A11)","v":""},{"$f":"IF('2. Basic calculator'!B11=\"\",\"\",'2. Basic calculator'!B11)","v":""},null,{"$f":"IF('2. Basic calculator'!C11=\"\",\"\",'2. Basic calculator'!C11)","v":""},{"$f":"IF('2. Basic calculator'!D11=\"\",\"\",'2. Basic calculator'!D11)","v":""},{"$f":"IF(B19=\"\",\"\",D19*VLOOKUP(B19,All,8,FALSE))","v":""},{"$f":"IF('2. Basic calculator'!E11=\"\",\"\",'2. Basic calculator'!E11)","v":""},{"$f":"IF(A19=\"\",\"\",IF(A19=\"Footbath\",F19/Q19/Herdentry2,IF(E19=\"Tubes\",D19/Q19/Herdentry2,IF(E19=\"Units\",F19/Q19/Herdentry2,'3. DDD DCD'!G19/'3. DDD DCD'!Q19))))","v":""},{"$f":"IF(A19=\"\",\"\",IF(A19=\"Footbath\",F19/R19/Herdentry2,IF(E19=\"Tubes\",D19/R19/Herdentry2,IF(E19=\"Units\",F19/R19/Herdentry2,'3. DDD DCD'!G19/'3. DDD DCD'!R19))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A12=\"\",\"\",'2. Basic calculator'!A12)","v":""},{"$f":"IF('2. Basic calculator'!B12=\"\",\"\",'2. Basic calculator'!B12)","v":""},null,{"$f":"IF('2. Basic calculator'!C12=\"\",\"\",'2. Basic calculator'!C12)","v":""},{"$f":"IF('2. Basic calculator'!D12=\"\",\"\",'2. Basic calculator'!D12)","v":""},"",{"$f":"IF('2. Basic calculator'!E12=\"\",\"\",'2. Basic calculator'!E12)","v":""},{"$f":"IF(A20=\"\",\"\",IF(A20=\"Footbath\",F20/Q20/Herdentry2,IF(E20=\"Tubes\",D20/Q20/Herdentry2,IF(E20=\"Units\",F20/Q20/Herdentry2,'3. DDD DCD'!G20/'3. DDD DCD'!Q20))))","v":""},{"$f":"IF(A20=\"\",\"\",IF(A20=\"Footbath\",F20/R20/Herdentry2,IF(E20=\"Tubes\",D20/R20/Herdentry2,IF(E20=\"Units\",F20/R20/Herdentry2,'3. DDD DCD'!G20/'3. DDD DCD'!R20))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A13=\"\",\"\",'2. Basic calculator'!A13)","v":""},{"$f":"IF('2. Basic calculator'!B13=\"\",\"\",'2. Basic calculator'!B13)","v":""},null,{"$f":"IF('2. Basic calculator'!C13=\"\",\"\",'2. Basic calculator'!C13)","v":""},{"$f":"IF('2. Basic calculator'!D13=\"\",\"\",'2. Basic calculator'!D13)","v":""},"",{"$f":"IF('2. Basic calculator'!E13=\"\",\"\",'2. Basic calculator'!E13)","v":""},{"$f":"IF(A21=\"\",\"\",IF(A21=\"Footbath\",F21/Q21/Herdentry2,IF(E21=\"Tubes\",D21/Q21/Herdentry2,IF(E21=\"Units\",F21/Q21/Herdentry2,'3. DDD DCD'!G21/'3. DDD DCD'!Q21))))","v":""},{"$f":"IF(A21=\"\",\"\",IF(A21=\"Footbath\",F21/R21/Herdentry2,IF(E21=\"Tubes\",D21/R21/Herdentry2,IF(E21=\"Units\",F21/R21/Herdentry2,'3. DDD DCD'!G21/'3. DDD DCD'!R21))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A14=\"\",\"\",'2. Basic calculator'!A14)","v":""},{"$f":"IF('2. Basic calculator'!B14=\"\",\"\",'2. Basic calculator'!B14)","v":""},null,{"$f":"IF('2. Basic calculator'!C14=\"\",\"\",'2. Basic calculator'!C14)","v":""},{"$f":"IF('2. Basic calculator'!D14=\"\",\"\",'2. Basic calculator'!D14)","v":""},"",{"$f":"IF('2. Basic calculator'!E14=\"\",\"\",'2. Basic calculator'!E14)","v":""},{"$f":"IF(A22=\"\",\"\",IF(A22=\"Footbath\",F22/Q22/Herdentry2,IF(E22=\"Tubes\",D22/Q22/Herdentry2,IF(E22=\"Units\",F22/Q22/Herdentry2,'3. DDD DCD'!G22/'3. DDD DCD'!Q22))))","v":""},{"$f":"IF(A22=\"\",\"\",IF(A22=\"Footbath\",F22/R22/Herdentry2,IF(E22=\"Tubes\",D22/R22/Herdentry2,IF(E22=\"Units\",F22/R22/Herdentry2,'3. DDD DCD'!G22/'3. DDD DCD'!R22))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A15=\"\",\"\",'2. Basic calculator'!A15)","v":""},{"$f":"IF('2. Basic calculator'!B15=\"\",\"\",'2. Basic calculator'!B15)","v":""},null,{"$f":"IF('2. Basic calculator'!C15=\"\",\"\",'2. Basic calculator'!C15)","v":""},{"$f":"IF('2. Basic calculator'!D15=\"\",\"\",'2. Basic calculator'!D15)","v":""},"",{"$f":"IF('2. Basic calculator'!E15=\"\",\"\",'2. Basic calculator'!E15)","v":""},{"$f":"IF(A23=\"\",\"\",IF(A23=\"Footbath\",F23/Q23/Herdentry2,IF(E23=\"Tubes\",D23/Q23/Herdentry2,IF(E23=\"Units\",F23/Q23/Herdentry2,'3. DDD DCD'!G23/'3. DDD DCD'!Q23))))","v":""},{"$f":"IF(A23=\"\",\"\",IF(A23=\"Footbath\",F23/R23/Herdentry2,IF(E23=\"Tubes\",D23/R23/Herdentry2,IF(E23=\"Units\",F23/R23/Herdentry2,'3. DDD DCD'!G23/'3. DDD DCD'!R23))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A16=\"\",\"\",'2. Basic calculator'!A16)","v":""},{"$f":"IF('2. Basic calculator'!B16=\"\",\"\",'2. Basic calculator'!B16)","v":""},null,{"$f":"IF('2. Basic calculator'!C16=\"\",\"\",'2. Basic calculator'!C16)","v":""},{"$f":"IF('2. Basic calculator'!D16=\"\",\"\",'2. Basic calculator'!D16)","v":""},"",{"$f":"IF('2. Basic calculator'!E16=\"\",\"\",'2. Basic calculator'!E16)","v":""},{"$f":"IF(A24=\"\",\"\",IF(A24=\"Footbath\",F24/Q24/Herdentry2,IF(E24=\"Tubes\",D24/Q24/Herdentry2,IF(E24=\"Units\",F24/Q24/Herdentry2,'3. DDD DCD'!G24/'3. DDD DCD'!Q24))))","v":""},{"$f":"IF(A24=\"\",\"\",IF(A24=\"Footbath\",F24/R24/Herdentry2,IF(E24=\"Tubes\",D24/R24/Herdentry2,IF(E24=\"Units\",F24/R24/Herdentry2,'3. DDD DCD'!G24/'3. DDD DCD'!R24))))","v":""},""," ",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A17=\"\",\"\",'2. Basic calculator'!A17)","v":""},{"$f":"IF('2. Basic calculator'!B17=\"\",\"\",'2. Basic calculator'!B17)","v":""},null,{"$f":"IF('2. Basic calculator'!C17=\"\",\"\",'2. Basic calculator'!C17)","v":""},{"$f":"IF('2. Basic calculator'!D17=\"\",\"\",'2. Basic calculator'!D17)","v":""},"",{"$f":"IF('2. Basic calculator'!E17=\"\",\"\",'2. Basic calculator'!E17)","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25=\"Footbath\",F25/Q25/Herdentry2,IF(E25=\"Tubes\",D25/Q25/Herdentry2,IF(E25=\"Units\",F25/Q25/Herdentry2,'3. DDD DCD'!G25/'3. DDD DCD'!Q25))))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25=\"Footbath\",F25/R25/Herdentry2,IF(E25=\"Tubes\",D25/R25/Herdentry2,IF(E25=\"Units\",F25/R25/Herdentry2,'3. DDD DCD'!G25/'3. DDD DCD'!R25))))","v":""},"",{"$f":"IF(B25=\"\",\"\",IF((VLOOKUP(B25,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""},null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A18=\"\",\"\",'2. Basic calculator'!A18)","v":""},{"$f":"IF('2. Basic calculator'!B18=\"\",\"\",'2. Basic calculator'!B18)","v":""},null,{"$f":"IF('2. Basic calculator'!C18=\"\",\"\",'2. Basic calculator'!C18)","v":""},{"$f":"IF('2. Basic calculator'!D18=\"\",\"\",'2. Basic calculator'!D18)","v":""},"",{"$f":"IF('2. Basic calculator'!E18=\"\",\"\",'2. Basic calculator'!E18)","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26=\"Footbath\",F26/Q26/Herdentry2,IF(E26=\"Tubes\",D26/Q26/Herdentry2,IF(E26=\"Units\",F26/Q26/Herdentry2,'3. DDD DCD'!G26/'3. DDD DCD'!Q26))))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26=\"Footbath\",F26/R26/Herdentry2,IF(E26=\"Tubes\",D26/R26/Herdentry2,IF(E26=\"Units\",F26/R26/Herdentry2,'3. DDD DCD'!G26/'3. DDD DCD'!R26))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A19=\"\",\"\",'2. Basic calculator'!A19)","v":""},{"$f":"IF('2. Basic calculator'!B19=\"\",\"\",'2. Basic calculator'!B19)","v":""},null,{"$f":"IF('2. Basic calculator'!C19=\"\",\"\",'2. Basic calculator'!C19)","v":""},{"$f":"IF('2. Basic calculator'!D19=\"\",\"\",'2. Basic calculator'!D19)","v":""},"",{"$f":"IF('2. Basic calculator'!E19=\"\",\"\",'2. Basic calculator'!E19)","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27=\"Footbath\",F27/Q27/Herdentry2,IF(E27=\"Tubes\",D27/Q27/Herdentry2,IF(E27=\"Units\",F27/Q27/Herdentry2,'3. DDD DCD'!G27/'3. DDD DCD'!Q27))))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27=\"Footbath\",F27/R27/Herdentry2,IF(E27=\"Tubes\",D27/R27/Herdentry2,IF(E27=\"Units\",F27/R27/Herdentry2,'3. DDD DCD'!G27/'3. DDD DCD'!R27))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A20=\"\",\"\",'2. Basic calculator'!A20)","v":""},{"$f":"IF('2. Basic calculator'!B20=\"\",\"\",'2. Basic calculator'!B20)","v":""},null,{"$f":"IF('2. Basic calculator'!C20=\"\",\"\",'2. Basic calculator'!C20)","v":""},{"$f":"IF('2. Basic calculator'!D20=\"\",\"\",'2. Basic calculator'!D20)","v":""},"",{"$f":"IF('2. Basic calculator'!E20=\"\",\"\",'2. Basic calculator'!E20)","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28=\"Footbath\",F28/Q28/Herdentry2,IF(E28=\"Tubes\",D28/Q28/Herdentry2,IF(E28=\"Units\",F28/Q28/Herdentry2,'3. DDD DCD'!G28/'3. DDD DCD'!Q28))))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28=\"Footbath\",F28/R28/Herdentry2,IF(E28=\"Tubes\",D28/R28/Herdentry2,IF(E28=\"Units\",F28/R28/Herdentry2,'3. DDD DCD'!G28/'3. DDD DCD'!R28))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A21=\"\",\"\",'2. Basic calculator'!A21)","v":""},{"$f":"IF('2. Basic calculator'!B21=\"\",\"\",'2. Basic calculator'!B21)","v":""},null,{"$f":"IF('2. Basic calculator'!C21=\"\",\"\",'2. Basic calculator'!C21)","v":""},{"$f":"IF('2. Basic calculator'!D21=\"\",\"\",'2. Basic calculator'!D21)","v":""},"",{"$f":"IF('2. Basic calculator'!E21=\"\",\"\",'2. Basic calculator'!E21)","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29=\"Footbath\",F29/Q29/Herdentry2,IF(E29=\"Tubes\",D29/Q29/Herdentry2,IF(E29=\"Units\",F29/Q29/Herdentry2,'3. DDD DCD'!G29/'3. DDD DCD'!Q29))))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29=\"Footbath\",F29/R29/Herdentry2,IF(E29=\"Tubes\",D29/R29/Herdentry2,IF(E29=\"Units\",F29/R29/Herdentry2,'3. DDD DCD'!G29/'3. DDD DCD'!R29))))","v":""},"","",null,null,null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(B29,All,10,FALSE))","v":""},"","",""]
[{"$f":"IF('2. Basic calculator'!A22=\"\",\"\",'2. Basic calculator'!A22)","v":""},{"$f":"IF('2. Basic calculator'!B22=\"\",\"\",'2. Basic calculator'!B22)","v":""},null,{"$f":"IF('2. Basic calculator'!C22=\"\",\"\",'2. Basic calculator'!C22)","v":""},{"$f":"IF('2. Basic calculator'!D22=\"\",\"\",'2. Basic calculator'!D22)","v":""},"",{"$f":"IF('2. Basic calculator'!E22=\"\",\"\",'2. Basic calculator'!E22)","v":""},{"$f":"IF(A30=\"\",\"\",IF(A30=\"Footbath\",F30/Q30/Herdentry2,IF(E30=\"Tubes\",D30/Q30/Herdentry2,IF(E30=\"Units\",F30/Q30/Herdentry2,'3. DDD DCD'!G30/'3. DDD DCD'!Q30))))","v":""},{"$f":"IF(A30=\"\",\"\",IF(A30=\"Footbath\",F30/R30/Herdentry2,IF(E30=\"Tubes\",D30/R30/Herdentry2,IF(E30=\"Units\",F30/R30/Herdentry2,'3. DDD DCD'!G30/'3. DDD DCD'!R30))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A23=\"\",\"\",'2. Basic calculator'!A23)","v":""},{"$f":"IF('2. Basic calculator'!B23=\"\",\"\",'2. Basic calculator'!B23)","v":""},null,{"$f":"IF('2. Basic calculator'!C23=\"\",\"\",'2. Basic calculator'!C23)","v":""},{"$f":"IF('2. Basic calculator'!D23=\"\",\"\",'2. Basic calculator'!D23)","v":""},"",{"$f":"IF('2. Basic calculator'!E23=\"\",\"\",'2. Basic calculator'!E23)","v":""},{"$f":"IF(A31=\"\",\"\",IF(A31=\"Footbath\",F31/Q31/Herdentry2,IF(E31=\"Tubes\",D31/Q31/Herdentry2,IF(E31=\"Units\",F31/Q31/Herdentry2,'3. DDD DCD'!G31/'3. DDD DCD'!Q31))))","v":""},{"$f":"IF(A31=\"\",\"\",IF(A31=\"Footbath\",F31/R31/Herdentry2,IF(E31=\"Tubes\",D31/R31/Herdentry2,IF(E31=\"Units\",F31/R31/Herdentry2,'3. DDD DCD'!G31/'3. DDD DCD'!R31))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A24=\"\",\"\",'2. Basic calculator'!A24)","v":""},{"$f":"IF('2. Basic calculator'!B24=\"\",\"\",'2. Basic calculator'!B24)","v":""},null,{"$f":"IF('2. Basic calculator'!C24=\"\",\"\",'2. Basic calculator'!C24)","v":""},{"$f":"IF('2. Basic calculator'!D24=\"\",\"\",'2. Basic calculator'!D24)","v":""},"",{"$f":"IF('2. Basic calculator'!E24=\"\",\"\",'2. Basic calculator'!E24)","v":""},{"$f":"IF(A32=\"\",\"\",IF(A32=\"Footbath\",F32/Q32/Herdentry2,IF(E32=\"Tubes\",D32/Q32/Herdentry2,IF(E32=\"Units\",F32/Q32/Herdentry2,'3. DDD DCD'!G32/'3. DDD DCD'!Q32))))","v":""},{"$f":"IF(A32=\"\",\"\",IF(A32=\"Footbath\",F32/R32/Herdentry2,IF(E32=\"Tubes\",D32/R32/Herdentry2,IF(E32=\"Units\",F32/R32/Herdentry2,'3. DDD DCD'!G32/'3. DDD DCD'!R32))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A25=\"\",\"\",'2. Basic calculator'!A25)","v":""},{"$f":"IF('2. Basic calculator'!B25=\"\",\"\",'2. Basic calculator'!B25)","v":""},null,{"$f":"IF('2. Basic calculator'!C25=\"\",\"\",'2. Basic calculator'!C25)","v":""},{"$f":"IF('2. Basic calculator'!D25=\"\",\"\",'2. Basic calculator'!D25)","v":""},"",{"$f":"IF('2. Basic calculator'!E25=\"\",\"\",'2. Basic calculator'!E25)","v":""},{"$f":"IF(A33=\"\",\"\",IF(A33=\"Footbath\",F33/Q33/Herdentry2,IF(E33=\"Tubes\",D33/Q33/Herdentry2,IF(E33=\"Units\",F33/Q33/Herdentry2,'3. DDD DCD'!G33/'3. DDD DCD'!Q33))))","v":""},{"$f":"IF(A33=\"\",\"\",IF(A33=\"Footbath\",F33/R33/Herdentry2,IF(E33=\"Tubes\",D33/R33/Herdentry2,IF(E33=\"Units\",F33/R33/Herdentry2,'3. DDD DCD'!G33/'3. DDD DCD'!R33))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A26=\"\",\"\",'2. Basic calculator'!A26)","v":""},{"$f":"IF('2. Basic calculator'!B26=\"\",\"\",'2. Basic calculator'!B26)","v":""},null,{"$f":"IF('2. Basic calculator'!C26=\"\",\"\",'2. Basic calculator'!C26)","v":""},{"$f":"IF('2. Basic calculator'!D26=\"\",\"\",'2. Basic calculator'!D26)","v":""},"",{"$f":"IF('2. Basic calculator'!E26=\"\",\"\",'2. Basic calculator'!E26)","v":""},{"$f":"IF(A34=\"\",\"\",IF(A34=\"Footbath\",F34/Q34/Herdentry2,IF(E34=\"Tubes\",D34/Q34/Herdentry2,IF(E34=\"Units\",F34/Q34/Herdentry2,'3. DDD DCD'!G34/'3. DDD DCD'!Q34))))","v":""},{"$f":"IF(A34=\"\",\"\",IF(A34=\"Footbath\",F34/R34/Herdentry2,IF(E34=\"Tubes\",D34/R34/Herdentry2,IF(E34=\"Units\",F34/R34/Herdentry2,'3. DDD DCD'!G34/'3. DDD DCD'!R34))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A27=\"\",\"\",'2. Basic calculator'!A27)","v":""},{"$f":"IF('2. Basic calculator'!B27=\"\",\"\",'2. Basic calculator'!B27)","v":""},null,{"$f":"IF('2. Basic calculator'!C27=\"\",\"\",'2. Basic calculator'!C27)","v":""},{"$f":"IF('2. Basic calculator'!D27=\"\",\"\",'2. Basic calculator'!D27)","v":""},"",{"$f":"IF('2. Basic calculator'!E27=\"\",\"\",'2. Basic calculator'!E27)","v":""},{"$f":"IF(A35=\"\",\"\",IF(A35=\"Footbath\",F35/Q35/Herdentry2,IF(E35=\"Tubes\",D35/Q35/Herdentry2,IF(E35=\"Units\",F35/Q35/Herdentry2,'3. DDD DCD'!G35/'3. DDD DCD'!Q35))))","v":""},{"$f":"IF(A35=\"\",\"\",IF(A35=\"Footbath\",F35/R35/Herdentry2,IF(E35=\"Tubes\",D35/R35/Herdentry2,IF(E35=\"Units\",F35/R35/Herdentry2,'3. DDD DCD'!G35/'3. DDD DCD'!R35))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A28=\"\",\"\",'2. Basic calculator'!A28)","v":""},{"$f":"IF('2. Basic calculator'!B28=\"\",\"\",'2. Basic calculator'!B28)","v":""},null,{"$f":"IF('2. Basic calculator'!C28=\"\",\"\",'2. Basic calculator'!C28)","v":""},{"$f":"IF('2. Basic calculator'!D28=\"\",\"\",'2. Basic calculator'!D28)","v":""},"",{"$f":"IF('2. Basic calculator'!E28=\"\",\"\",'2. Basic calculator'!E28)","v":""},{"$f":"IF(A36=\"\",\"\",IF(A36=\"Footbath\",F36/Q36/Herdentry2,IF(E36=\"Tubes\",D36/Q36/Herdentry2,IF(E36=\"Units\",F36/Q36/Herdentry2,'3. DDD DCD'!G36/'3. DDD DCD'!Q36))))","v":""},{"$f":"IF(A36=\"\",\"\",IF(A36=\"Footbath\",F36/R36/Herdentry2,IF(E36=\"Tubes\",D36/R36/Herdentry2,IF(E36=\"Units\",F36/R36/Herdentry2,'3. DDD DCD'!G36/'3. DDD DCD'!R36))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A29=\"\",\"\",'2. Basic calculator'!A29)","v":""},{"$f":"IF('2. Basic calculator'!B29=\"\",\"\",'2. Basic calculator'!B29)","v":""},null,{"$f":"IF('2. Basic calculator'!C29=\"\",\"\",'2. Basic calculator'!C29)","v":""},{"$f":"IF('2. Basic calculator'!D29=\"\",\"\",'2. Basic calculator'!D29)","v":""},"",{"$f":"IF('2. Basic calculator'!E29=\"\",\"\",'2. Basic calculator'!E29)","v":""},{"$f":"IF(A37=\"\",\"\",IF(A37=\"Footbath\",F37/Q37/Herdentry2,IF(E37=\"Tubes\",D37/Q37/Herdentry2,IF(E37=\"Units\",F37/Q37/Herdentry2,'3. DDD DCD'!G37/'3. DDD DCD'!Q37))))","v":""},{"$f":"IF(A37=\"\",\"\",IF(A37=\"Footbath\",F37/R37/Herdentry2,IF(E37=\"Tubes\",D37/R37/Herdentry2,IF(E37=\"Units\",F37/R37/Herdentry2,'3. DDD DCD'!G37/'3. DDD DCD'!R37))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A30=\"\",\"\",'2. Basic calculator'!A30)","v":""},{"$f":"IF('2. Basic calculator'!B30=\"\",\"\",'2. Basic calculator'!B30)","v":""},null,{"$f":"IF('2. Basic calculator'!C30=\"\",\"\",'2. Basic calculator'!C30)","v":""},{"$f":"IF('2. Basic calculator'!D30=\"\",\"\",'2. Basic calculator'!D30)","v":""},"",{"$f":"IF('2. Basic calculator'!E30=\"\",\"\",'2. Basic calculator'!E30)","v":""},{"$f":"IF(A38=\"\",\"\",IF(A38=\"Footbath\",F38/Q38/Herdentry2,IF(E38=\"Tubes\",D38/Q38/Herdentry2,IF(E38=\"Units\",F38/Q38/Herdentry2,'3. DDD DCD'!G38/'3. DDD DCD'!Q38))))","v":""},{"$f":"IF(A38=\"\",\"\",IF(A38=\"Footbath\",F38/R38/Herdentry2,IF(E38=\"Tubes\",D38/R38/Herdentry2,IF(E38=\"Units\",F38/R38/Herdentry2,'3. DDD DCD'!G38/'3. DDD DCD'!R38))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A31=\"\",\"\",'2. Basic calculator'!A31)","v":""},{"$f":"IF('2. Basic calculator'!B31=\"\",\"\",'2. Basic calculator'!B31)","v":""},null,{"$f":"IF('2. Basic calculator'!C31=\"\",\"\",'2. Basic calculator'!C31)","v":""},{"$f":"IF('2. Basic calculator'!D31=\"\",\"\",'2. Basic calculator'!D31)","v":""},"",{"$f":"IF('2. Basic calculator'!E31=\"\",\"\",'2. Basic calculator'!E31)","v":""},{"$f":"IF(A39=\"\",\"\",IF(A39=\"Footbath\",F39/Q39/Herdentry2,IF(E39=\"Tubes\",D39/Q39/Herdentry2,IF(E39=\"Units\",F39/Q39/Herdentry2,'3. DDD DCD'!G39/'3. DDD DCD'!Q39))))","v":""},{"$f":"IF(A39=\"\",\"\",IF(A39=\"Footbath\",F39/R39/Herdentry2,IF(E39=\"Tubes\",D39/R39/Herdentry2,IF(E39=\"Units\",F39/R39/Herdentry2,'3. DDD DCD'!G39/'3. DDD DCD'!R39))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A32=\"\",\"\",'2. Basic calculator'!A32)","v":""},{"$f":"IF('2. Basic calculator'!B32=\"\",\"\",'2. Basic calculator'!B32)","v":""},null,{"$f":"IF('2. Basic calculator'!C32=\"\",\"\",'2. Basic calculator'!C32)","v":""},{"$f":"IF('2. Basic calculator'!D32=\"\",\"\",'2. Basic calculator'!D32)","v":""},"",{"$f":"IF('2. Basic calculator'!E32=\"\",\"\",'2. Basic calculator'!E32)","v":""},{"$f":"IF(A40=\"\",\"\",IF(A40=\"Footbath\",F40/Q40/Herdentry2,IF(E40=\"Tubes\",D40/Q40/Herdentry2,IF(E40=\"Units\",F40/Q40/Herdentry2,'3. DDD DCD'!G40/'3. DDD DCD'!Q40))))","v":""},{"$f":"IF(A40=\"\",\"\",IF(A40=\"Footbath\",F40/R40/Herdentry2,IF(E40=\"Tubes\",D40/R40/Herdentry2,IF(E40=\"Units\",F40/R40/Herdentry2,'3. DDD DCD'!G40/'3. DDD DCD'!R40))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A33=\"\",\"\",'2. Basic calculator'!A33)","v":""},{"$f":"IF('2. Basic calculator'!B33=\"\",\"\",'2. Basic calculator'!B33)","v":""},null,{"$f":"IF('2. Basic calculator'!C33=\"\",\"\",'2. Basic calculator'!C33)","v":""},{"$f":"IF('2. Basic calculator'!D33=\"\",\"\",'2. Basic calculator'!D33)","v":""},"",{"$f":"IF('2. Basic calculator'!E33=\"\",\"\",'2. Basic calculator'!E33)","v":""},{"$f":"IF(A41=\"\",\"\",IF(A41=\"Footbath\",F41/Q41/Herdentry2,IF(E41=\"Tubes\",D41/Q41/Herdentry2,IF(E41=\"Units\",F41/Q41/Herdentry2,'3. DDD DCD'!G41/'3. DDD DCD'!Q41))))","v":""},{"$f":"IF(A41=\"\",\"\",IF(A41=\"Footbath\",F41/R41/Herdentry2,IF(E41=\"Tubes\",D41/R41/Herdentry2,IF(E41=\"Units\",F41/R41/Herdentry2,'3. DDD DCD'!G41/'3. DDD DCD'!R41))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A34=\"\",\"\",'2. Basic calculator'!A34)","v":""},{"$f":"IF('2. Basic calculator'!B34=\"\",\"\",'2. Basic calculator'!B34)","v":""},null,{"$f":"IF('2. Basic calculator'!C34=\"\",\"\",'2. Basic calculator'!C34)","v":""},{"$f":"IF('2. Basic calculator'!D34=\"\",\"\",'2. Basic calculator'!D34)","v":""},"",{"$f":"IF('2. Basic calculator'!E34=\"\",\"\",'2. Basic calculator'!E34)","v":""},{"$f":"IF(A42=\"\",\"\",IF(A42=\"Footbath\",F42/Q42/Herdentry2,IF(E42=\"Tubes\",D42/Q42/Herdentry2,IF(E42=\"Units\",F42/Q42/Herdentry2,'3. DDD DCD'!G42/'3. DDD DCD'!Q42))))","v":""},{"$f":"IF(A42=\"\",\"\",IF(A42=\"Footbath\",F42/R42/Herdentry2,IF(E42=\"Tubes\",D42/R42/Herdentry2,IF(E42=\"Units\",F42/R42/Herdentry2,'3. DDD DCD'!G42/'3. DDD DCD'!R42))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A35=\"\",\"\",'2. Basic calculator'!A35)","v":""},{"$f":"IF('2. Basic calculator'!B35=\"\",\"\",'2. Basic calculator'!B35)","v":""},null,{"$f":"IF('2. Basic calculator'!C35=\"\",\"\",'2. Basic calculator'!C35)","v":""},{"$f":"IF('2. Basic calculator'!D35=\"\",\"\",'2. Basic calculator'!D35)","v":""},"",{"$f":"IF('2. Basic calculator'!E35=\"\",\"\",'2. Basic calculator'!E35)","v":""},{"$f":"IF(A43=\"\",\"\",IF(A43=\"Footbath\",F43/Q43/Herdentry2,IF(E43=\"Tubes\",D43/Q43/Herdentry2,IF(E43=\"Units\",F43/Q43/Herdentry2,'3. DDD DCD'!G43/'3. DDD DCD'!Q43))))","v":""},{"$f":"IF(A43=\"\",\"\",IF(A43=\"Footbath\",F43/R43/Herdentry2,IF(E43=\"Tubes\",D43/R43/Herdentry2,IF(E43=\"Units\",F43/R43/Herdentry2,'3. DDD DCD'!G43/'3. DDD DCD'!R43))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A36=\"\",\"\",'2. Basic calculator'!A36)","v":""},{"$f":"IF('2. Basic calculator'!B36=\"\",\"\",'2. Basic calculator'!B36)","v":""},null,{"$f":"IF('2. Basic calculator'!C36=\"\",\"\",'2. Basic calculator'!C36)","v":""},{"$f":"IF('2. Basic calculator'!D36=\"\",\"\",'2. Basic calculator'!D36)","v":""},"",{"$f":"IF('2. Basic calculator'!E36=\"\",\"\",'2. Basic calculator'!E36)","v":""},{"$f":"IF(A44=\"\",\"\",IF(A44=\"Footbath\",F44/Q44/Herdentry2,IF(E44=\"Tubes\",D44/Q44/Herdentry2,IF(E44=\"Units\",F44/Q44/Herdentry2,'3. DDD DCD'!G44/'3. DDD DCD'!Q44))))","v":""},{"$f":"IF(A44=\"\",\"\",IF(A44=\"Footbath\",F44/R44/Herdentry2,IF(E44=\"Tubes\",D44/R44/Herdentry2,IF(E44=\"Units\",F44/R44/Herdentry2,'3. DDD DCD'!G44/'3. DDD DCD'!R44))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A37=\"\",\"\",'2. Basic calculator'!A37)","v":""},{"$f":"IF('2. Basic calculator'!B37=\"\",\"\",'2. Basic calculator'!B37)","v":""},null,{"$f":"IF('2. Basic calculator'!C37=\"\",\"\",'2. Basic calculator'!C37)","v":""},{"$f":"IF('2. Basic calculator'!D37=\"\",\"\",'2. Basic calculator'!D37)","v":""},"",{"$f":"IF('2. Basic calculator'!E37=\"\",\"\",'2. Basic calculator'!E37)","v":""},{"$f":"IF(A45=\"\",\"\",IF(A45=\"Footbath\",F45/Q45/Herdentry2,IF(E45=\"Tubes\",D45/Q45/Herdentry2,IF(E45=\"Units\",F45/Q45/Herdentry2,'3. DDD DCD'!G45/'3. DDD DCD'!Q45))))","v":""},{"$f":"IF(A45=\"\",\"\",IF(A45=\"Footbath\",F45/R45/Herdentry2,IF(E45=\"Tubes\",D45/R45/Herdentry2,IF(E45=\"Units\",F45/R45/Herdentry2,'3. DDD DCD'!G45/'3. DDD DCD'!R45))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A38=\"\",\"\",'2. Basic calculator'!A38)","v":""},{"$f":"IF('2. Basic calculator'!B38=\"\",\"\",'2. Basic calculator'!B38)","v":""},null,{"$f":"IF('2. Basic calculator'!C38=\"\",\"\",'2. Basic calculator'!C38)","v":""},{"$f":"IF('2. Basic calculator'!D38=\"\",\"\",'2. Basic calculator'!D38)","v":""},"",{"$f":"IF('2. Basic calculator'!E38=\"\",\"\",'2. Basic calculator'!E38)","v":""},{"$f":"IF(A46=\"\",\"\",IF(A46=\"Footbath\",F46/Q46/Herdentry2,IF(E46=\"Tubes\",D46/Q46/Herdentry2,IF(E46=\"Units\",F46/Q46/Herdentry2,'3. DDD DCD'!G46/'3. DDD DCD'!Q46))))","v":""},{"$f":"IF(A46=\"\",\"\",IF(A46=\"Footbath\",F46/R46/Herdentry2,IF(E46=\"Tubes\",D46/R46/Herdentry2,IF(E46=\"Units\",F46/R46/Herdentry2,'3. DDD DCD'!G46/'3. DDD DCD'!R46))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A39=\"\",\"\",'2. Basic calculator'!A39)","v":""},{"$f":"IF('2. Basic calculator'!B39=\"\",\"\",'2. Basic calculator'!B39)","v":""},null,{"$f":"IF('2. Basic calculator'!C39=\"\",\"\",'2. Basic calculator'!C39)","v":""},{"$f":"IF('2. Basic calculator'!D39=\"\",\"\",'2. Basic calculator'!D39)","v":""},{"$f":"IF(B47=\"\",\"\",D47*VLOOKUP(B47,All,8,FALSE))","v":""},{"$f":"IF('2. Basic calculator'!E39=\"\",\"\",'2. Basic calculator'!E39)","v":""},{"$f":"IF(A47=\"\",\"\",IF(A47=\"Footbath\",F47/Q47/Herdentry2,IF(E47=\"Tubes\",D47/Q47/Herdentry2,IF(E47=\"Units\",F47/Q47/Herdentry2,'3. DDD DCD'!G47/'3. DDD DCD'!Q47))))","v":""},{"$f":"IF(A47=\"\",\"\",IF(A47=\"Footbath\",F47/R47/Herdentry2,IF(E47=\"Tubes\",D47/R47/Herdentry2,IF(E47=\"Units\",F47/R47/Herdentry2,'3. DDD DCD'!G47/'3. DDD DCD'!R47))))","v":""},"","",null,null,null,null,null,{"$f":"IF(A47=\"\",\"\",VLOOKUP(B47,All,10,FALSE))","v":""},{"$f":"IF(A47=\"\",\"\",VLOOKUP(B47,All,11,FALSE))","v":""},""]
[{"$f":"IF('2. Basic calculator'!A40=\"\",\"\",'2. Basic calculator'!A40)","v":""},{"$f":"IF('2. Basic calculator'!B40=\"\",\"\",'2. Basic calculator'!B40)","v":""},null,{"$f":"IF('2. Basic calculator'!C40=\"\",\"\",'2. Basic calculator'!C40)","v":""},{"$f":"IF('2. Basic calculator'!D40=\"\",\"\",'2. Basic calculator'!D40)","v":""},"",{"$f":"IF('2. Basic calculator'!E40=\"\",\"\",'2. Basic calculator'!E40)","v":""},{"$f":"IF(A48=\"\",\"\",IF(A48=\"Footbath\",F48/Q48/Herdentry2,IF(E48=\"Tubes\",D48/Q48/Herdentry2,IF(E48=\"Units\",F48/Q48/Herdentry2,'3. DDD DCD'!G48/'3. DDD DCD'!Q48))))","v":""},{"$f":"IF(A48=\"\",\"\",IF(A48=\"Footbath\",F48/R48/Herdentry2,IF(E48=\"Tubes\",D48/R48/Herdentry2,IF(E48=\"Units\",F48/R48/Herdentry2,'3. DDD DCD'!G48/'3. DDD DCD'!R48))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A41=\"\",\"\",'2. Basic calculator'!A41)","v":""},{"$f":"IF('2. Basic calculator'!B41=\"\",\"\",'2. Basic calculator'!B41)","v":""},null,{"$f":"IF('2. Basic calculator'!C41=\"\",\"\",'2. Basic calculator'!C41)","v":""},{"$f":"IF('2. Basic calculator'!D41=\"\",\"\",'2. Basic calculator'!D41)","v":""},"",{"$f":"IF('2. Basic calculator'!E41=\"\",\"\",'2. Basic calculator'!E41)","v":""},{"$f":"IF(A49=\"\",\"\",IF(A49=\"Footbath\",F49/Q49/Herdentry2,IF(E49=\"Tubes\",D49/Q49/Herdentry2,IF(E49=\"Units\",F49/Q49/Herdentry2,'3. DDD DCD'!G49/'3. DDD DCD'!Q49))))","v":""},{"$f":"IF(A49=\"\",\"\",IF(A49=\"Footbath\",F49/R49/Herdentry2,IF(E49=\"Tubes\",D49/R49/Herdentry2,IF(E49=\"Units\",F49/R49/Herdentry2,'3. DDD DCD'!G49/'3. DDD DCD'!R49))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A42=\"\",\"\",'2. Basic calculator'!A42)","v":""},{"$f":"IF('2. Basic calculator'!B42=\"\",\"\",'2. Basic calculator'!B42)","v":""},null,{"$f":"IF('2. Basic calculator'!C42=\"\",\"\",'2. Basic calculator'!C42)","v":""},{"$f":"IF('2. Basic calculator'!D42=\"\",\"\",'2. Basic calculator'!D42)","v":""},"",{"$f":"IF('2. Basic calculator'!E42=\"\",\"\",'2. Basic calculator'!E42)","v":""},{"$f":"IF(A50=\"\",\"\",IF(A50=\"Footbath\",F50/Q50/Herdentry2,IF(E50=\"Tubes\",D50/Q50/Herdentry2,IF(E50=\"Units\",F50/Q50/Herdentry2,'3. DDD DCD'!G50/'3. DDD DCD'!Q50))))","v":""},{"$f":"IF(A50=\"\",\"\",IF(A50=\"Footbath\",F50/R50/Herdentry2,IF(E50=\"Tubes\",D50/R50/Herdentry2,IF(E50=\"Units\",F50/R50/Herdentry2,'3. DDD DCD'!G50/'3. DDD DCD'!R50))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A43=\"\",\"\",'2. Basic calculator'!A43)","v":""},{"$f":"IF('2. Basic calculator'!B43=\"\",\"\",'2. Basic calculator'!B43)","v":""},null,{"$f":"IF('2. Basic calculator'!C43=\"\",\"\",'2. Basic calculator'!C43)","v":""},{"$f":"IF('2. Basic calculator'!D43=\"\",\"\",'2. Basic calculator'!D43)","v":""},"",{"$f":"IF('2. Basic calculator'!E43=\"\",\"\",'2. Basic calculator'!E43)","v":""},{"$f":"IF(A51=\"\",\"\",IF(A51=\"Footbath\",F51/Q51/Herdentry2,IF(E51=\"Tubes\",D51/Q51/Herdentry2,IF(E51=\"Units\",F51/Q51/Herdentry2,'3. DDD DCD'!G51/'3. DDD DCD'!Q51))))","v":""},{"$f":"IF(A51=\"\",\"\",IF(A51=\"Footbath\",F51/R51/Herdentry2,IF(E51=\"Tubes\",D51/R51/Herdentry2,IF(E51=\"Units\",F51/R51/Herdentry2,'3. DDD DCD'!G51/'3. DDD DCD'!R51))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A44=\"\",\"\",'2. Basic calculator'!A44)","v":""},{"$f":"IF('2. Basic calculator'!B44=\"\",\"\",'2. Basic calculator'!B44)","v":""},null,{"$f":"IF('2. Basic calculator'!C44=\"\",\"\",'2. Basic calculator'!C44)","v":""},{"$f":"IF('2. Basic calculator'!D44=\"\",\"\",'2. Basic calculator'!D44)","v":""},"",{"$f":"IF('2. Basic calculator'!E44=\"\",\"\",'2. Basic calculator'!E44)","v":""},{"$f":"IF(A52=\"\",\"\",IF(A52=\"Footbath\",F52/Q52/Herdentry2,IF(E52=\"Tubes\",D52/Q52/Herdentry2,IF(E52=\"Units\",F52/Q52/Herdentry2,'3. DDD DCD'!G52/'3. DDD DCD'!Q52))))","v":""},{"$f":"IF(A52=\"\",\"\",IF(A52=\"Footbath\",F52/R52/Herdentry2,IF(E52=\"Tubes\",D52/R52/Herdentry2,IF(E52=\"Units\",F52/R52/Herdentry2,'3. DDD DCD'!G52/'3. DDD DCD'!R52))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A45=\"\",\"\",'2. Basic calculator'!A45)","v":""},{"$f":"IF('2. Basic calculator'!B45=\"\",\"\",'2. Basic calculator'!B45)","v":""},null,{"$f":"IF('2. Basic calculator'!C45=\"\",\"\",'2. Basic calculator'!C45)","v":""},{"$f":"IF('2. Basic calculator'!D45=\"\",\"\",'2. Basic calculator'!D45)","v":""},"",{"$f":"IF('2. Basic calculator'!E45=\"\",\"\",'2. Basic calculator'!E45)","v":""},{"$f":"IF(A53=\"\",\"\",IF(A53=\"Footbath\",F53/Q53/Herdentry2,IF(E53=\"Tubes\",D53/Q53/Herdentry2,IF(E53=\"Units\",F53/Q53/Herdentry2,'3. DDD DCD'!G53/'3. DDD DCD'!Q53))))","v":""},{"$f":"IF(A53=\"\",\"\",IF(A53=\"Footbath\",F53/R53/Herdentry2,IF(E53=\"Tubes\",D53/R53/Herdentry2,IF(E53=\"Units\",F53/R53/Herdentry2,'3. DDD DCD'!G53/'3. DDD DCD'!R53))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A46=\"\",\"\",'2. Basic calculator'!A46)","v":""},{"$f":"IF('2. Basic calculator'!B46=\"\",\"\",'2. Basic calculator'!B46)","v":""},null,{"$f":"IF('2. Basic calculator'!C46=\"\",\"\",'2. Basic calculator'!C46)","v":""},{"$f":"IF('2. Basic calculator'!D46=\"\",\"\",'2. Basic calculator'!D46)","v":""},"",{"$f":"IF('2. Basic calculator'!E46=\"\",\"\",'2. Basic calculator'!E46)","v":""},{"$f":"IF(A54=\"\",\"\",IF(A54=\"Footbath\",F54/Q54/Herdentry2,IF(E54=\"Tubes\",D54/Q54/Herdentry2,IF(E54=\"Units\",F54/Q54/Herdentry2,'3. DDD DCD'!G54/'3. DDD DCD'!Q54))))","v":""},{"$f":"IF(A54=\"\",\"\",IF(A54=\"Footbath\",F54/R54/Herdentry2,IF(E54=\"Tubes\",D54/R54/Herdentry2,IF(E54=\"Units\",F54/R54/Herdentry2,'3. DDD DCD'!G54/'3. DDD DCD'!R54))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A47=\"\",\"\",'2. Basic calculator'!A47)","v":""},{"$f":"IF('2. Basic calculator'!B47=\"\",\"\",'2. Basic calculator'!B47)","v":""},null,{"$f":"IF('2. Basic calculator'!C47=\"\",\"\",'2. Basic calculator'!C47)","v":""},{"$f":"IF('2. Basic calculator'!D47=\"\",\"\",'2. Basic calculator'!D47)","v":""},"",{"$f":"IF('2. Basic calculator'!E47=\"\",\"\",'2. Basic calculator'!E47)","v":""},{"$f":"IF(A55=\"\",\"\",IF(A55=\"Footbath\",F55/Q55/Herdentry2,IF(E55=\"Tubes\",D55/Q55/Herdentry2,IF(E55=\"Units\",F55/Q55/Herdentry2,'3. DDD DCD'!G55/'3. DDD DCD'!Q55))))","v":""},{"$f":"IF(A55=\"\",\"\",IF(A55=\"Footbath\",F55/R55/Herdentry2,IF(E55=\"Tubes\",D55/R55/Herdentry2,IF(E55=\"Units\",F55/R55/Herdentry2,'3. DDD DCD'!G55/'3. DDD DCD'!R55))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A48=\"\",\"\",'2. Basic calculator'!A48)","v":""},{"$f":"IF('2. Basic calculator'!B48=\"\",\"\",'2. Basic calculator'!B48)","v":""},null,{"$f":"IF('2. Basic calculator'!C48=\"\",\"\",'2. Basic calculator'!C48)","v":""},{"$f":"IF('2. Basic calculator'!D48=\"\",\"\",'2. Basic calculator'!D48)","v":""},"",{"$f":"IF('2. Basic calculator'!E48=\"\",\"\",'2. Basic calculator'!E48)","v":""},{"$f":"IF(A56=\"\",\"\",IF(A56=\"Footbath\",F56/Q56/Herdentry2,IF(E56=\"Tubes\",D56/Q56/Herdentry2,IF(E56=\"Units\",F56/Q56/Herdentry2,'3. DDD DCD'!G56/'3. DDD DCD'!Q56))))","v":""},{"$f":"IF(A56=\"\",\"\",IF(A56=\"Footbath\",F56/R56/Herdentry2,IF(E56=\"Tubes\",D56/R56/Herdentry2,IF(E56=\"Units\",F56/R56/Herdentry2,'3. DDD DCD'!G56/'3. DDD DCD'!R56))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A49=\"\",\"\",'2. Basic calculator'!A49)","v":""},{"$f":"IF('2. Basic calculator'!B49=\"\",\"\",'2. Basic calculator'!B49)","v":""},null,{"$f":"IF('2. Basic calculator'!C49=\"\",\"\",'2. Basic calculator'!C49)","v":""},{"$f":"IF('2. Basic calculator'!D49=\"\",\"\",'2. Basic calculator'!D49)","v":""},"",{"$f":"IF('2. Basic calculator'!E49=\"\",\"\",'2. Basic calculator'!E49)","v":""},{"$f":"IF(A57=\"\",\"\",IF(A57=\"Footbath\",F57/Q57/Herdentry2,IF(E57=\"Tubes\",D57/Q57/Herdentry2,IF(E57=\"Units\",F57/Q57/Herdentry2,'3. DDD DCD'!G57/'3. DDD DCD'!Q57))))","v":""},{"$f":"IF(A57=\"\",\"\",IF(A57=\"Footbath\",F57/R57/Herdentry2,IF(E57=\"Tubes\",D57/R57/Herdentry2,IF(E57=\"Units\",F57/R57/Herdentry2,'3. DDD DCD'!G57/'3. DDD DCD'!R57))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A50=\"\",\"\",'2. Basic calculator'!A50)","v":""},{"$f":"IF('2. Basic calculator'!B50=\"\",\"\",'2. Basic calculator'!B50)","v":""},null,{"$f":"IF('2. Basic calculator'!C50=\"\",\"\",'2. Basic calculator'!C50)","v":""},{"$f":"IF('2. Basic calculator'!D50=\"\",\"\",'2. Basic calculator'!D50)","v":""},"",{"$f":"IF('2. Basic calculator'!E50=\"\",\"\",'2. Basic calculator'!E50)","v":""},{"$f":"IF(A58=\"\",\"\",IF(A58=\"Footbath\",F58/Q58/Herdentry2,IF(E58=\"Tubes\",D58/Q58/Herdentry2,IF(E58=\"Units\",F58/Q58/Herdentry2,'3. DDD DCD'!G58/'3. DDD DCD'!Q58))))","v":""},{"$f":"IF(A58=\"\",\"\",IF(A58=\"Footbath\",F58/R58/Herdentry2,IF(E58=\"Tubes\",D58/R58/Herdentry2,IF(E58=\"Units\",F58/R58/Herdentry2,'3. DDD DCD'!G58/'3. DDD DCD'!R58))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A51=\"\",\"\",'2. Basic calculator'!A51)","v":""},{"$f":"IF('2. Basic calculator'!B51=\"\",\"\",'2. Basic calculator'!B51)","v":""},null,{"$f":"IF('2. Basic calculator'!C51=\"\",\"\",'2. Basic calculator'!C51)","v":""},{"$f":"IF('2. Basic calculator'!D51=\"\",\"\",'2. Basic calculator'!D51)","v":""},"",{"$f":"IF('2. Basic calculator'!E51=\"\",\"\",'2. Basic calculator'!E51)","v":""},{"$f":"IF(A59=\"\",\"\",IF(A59=\"Footbath\",F59/Q59/Herdentry2,IF(E59=\"Tubes\",D59/Q59/Herdentry2,IF(E59=\"Units\",F59/Q59/Herdentry2,'3. DDD DCD'!G59/'3. DDD DCD'!Q59))))","v":""},{"$f":"IF(A59=\"\",\"\",IF(A59=\"Footbath\",F59/R59/Herdentry2,IF(E59=\"Tubes\",D59/R59/Herdentry2,IF(E59=\"Units\",F59/R59/Herdentry2,'3. DDD DCD'!G59/'3. DDD DCD'!R59))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A52=\"\",\"\",'2. Basic calculator'!A52)","v":""},{"$f":"IF('2. Basic calculator'!B52=\"\",\"\",'2. Basic calculator'!B52)","v":""},null,{"$f":"IF('2. Basic calculator'!C52=\"\",\"\",'2. Basic calculator'!C52)","v":""},{"$f":"IF('2. Basic calculator'!D52=\"\",\"\",'2. Basic calculator'!D52)","v":""},"",{"$f":"IF('2. Basic calculator'!E52=\"\",\"\",'2. Basic calculator'!E52)","v":""},{"$f":"IF(A60=\"\",\"\",IF(A60=\"Footbath\",F60/Q60/Herdentry2,IF(E60=\"Tubes\",D60/Q60/Herdentry2,IF(E60=\"Units\",F60/Q60/Herdentry2,'3. DDD DCD'!G60/'3. DDD DCD'!Q60))))","v":""},{"$f":"IF(A60=\"\",\"\",IF(A60=\"Footbath\",F60/R60/Herdentry2,IF(E60=\"Tubes\",D60/R60/Herdentry2,IF(E60=\"Units\",F60/R60/Herdentry2,'3. DDD DCD'!G60/'3. DDD DCD'!R60))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A53=\"\",\"\",'2. Basic calculator'!A53)","v":""},{"$f":"IF('2. Basic calculator'!B53=\"\",\"\",'2. Basic calculator'!B53)","v":""},null,{"$f":"IF('2. Basic calculator'!C53=\"\",\"\",'2. Basic calculator'!C53)","v":""},{"$f":"IF('2. Basic calculator'!D53=\"\",\"\",'2. Basic calculator'!D53)","v":""},"",{"$f":"IF('2. Basic calculator'!E53=\"\",\"\",'2. Basic calculator'!E53)","v":""},{"$f":"IF(A61=\"\",\"\",IF(A61=\"Footbath\",F61/Q61/Herdentry2,IF(E61=\"Tubes\",D61/Q61/Herdentry2,IF(E61=\"Units\",F61/Q61/Herdentry2,'3. DDD DCD'!G61/'3. DDD DCD'!Q61))))","v":""},{"$f":"IF(A61=\"\",\"\",IF(A61=\"Footbath\",F61/R61/Herdentry2,IF(E61=\"Tubes\",D61/R61/Herdentry2,IF(E61=\"Units\",F61/R61/Herdentry2,'3. DDD DCD'!G61/'3. DDD DCD'!R61))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A54=\"\",\"\",'2. Basic calculator'!A54)","v":""},{"$f":"IF('2. Basic calculator'!B54=\"\",\"\",'2. Basic calculator'!B54)","v":""},null,{"$f":"IF('2. Basic calculator'!C54=\"\",\"\",'2. Basic calculator'!C54)","v":""},{"$f":"IF('2. Basic calculator'!D54=\"\",\"\",'2. Basic calculator'!D54)","v":""},"",{"$f":"IF('2. Basic calculator'!E54=\"\",\"\",'2. Basic calculator'!E54)","v":""},{"$f":"IF(A62=\"\",\"\",IF(A62=\"Footbath\",F62/Q62/Herdentry2,IF(E62=\"Tubes\",D62/Q62/Herdentry2,IF(E62=\"Units\",F62/Q62/Herdentry2,'3. DDD DCD'!G62/'3. DDD DCD'!Q62))))","v":""},{"$f":"IF(A62=\"\",\"\",IF(A62=\"Footbath\",F62/R62/Herdentry2,IF(E62=\"Tubes\",D62/R62/Herdentry2,IF(E62=\"Units\",F62/R62/Herdentry2,'3. DDD DCD'!G62/'3. DDD DCD'!R62))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A55=\"\",\"\",'2. Basic calculator'!A55)","v":""},{"$f":"IF('2. Basic calculator'!B55=\"\",\"\",'2. Basic calculator'!B55)","v":""},null,{"$f":"IF('2. Basic calculator'!C55=\"\",\"\",'2. Basic calculator'!C55)","v":""},{"$f":"IF('2. Basic calculator'!D55=\"\",\"\",'2. Basic calculator'!D55)","v":""},"",{"$f":"IF('2. Basic calculator'!E55=\"\",\"\",'2. Basic calculator'!E55)","v":""},{"$f":"IF(A63=\"\",\"\",IF(A63=\"Footbath\",F63/Q63/Herdentry2,IF(E63=\"Tubes\",D63/Q63/Herdentry2,IF(E63=\"Units\",F63/Q63/Herdentry2,'3. DDD DCD'!G63/'3. DDD DCD'!Q63))))","v":""},{"$f":"IF(A63=\"\",\"\",IF(A63=\"Footbath\",F63/R63/Herdentry2,IF(E63=\"Tubes\",D63/R63/Herdentry2,IF(E63=\"Units\",F63/R63/Herdentry2,'3. DDD DCD'!G63/'3. DDD DCD'!R63))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A56=\"\",\"\",'2. Basic calculator'!A56)","v":""},{"$f":"IF('2. Basic calculator'!B56=\"\",\"\",'2. Basic calculator'!B56)","v":""},null,{"$f":"IF('2. Basic calculator'!C56=\"\",\"\",'2. Basic calculator'!C56)","v":""},{"$f":"IF('2. Basic calculator'!D56=\"\",\"\",'2. Basic calculator'!D56)","v":""},"",{"$f":"IF('2. Basic calculator'!E56=\"\",\"\",'2. Basic calculator'!E56)","v":""},{"$f":"IF(A64=\"\",\"\",IF(A64=\"Footbath\",F64/Q64/Herdentry2,IF(E64=\"Tubes\",D64/Q64/Herdentry2,IF(E64=\"Units\",F64/Q64/Herdentry2,'3. DDD DCD'!G64/'3. DDD DCD'!Q64))))","v":""},{"$f":"IF(A64=\"\",\"\",IF(A64=\"Footbath\",F64/R64/Herdentry2,IF(E64=\"Tubes\",D64/R64/Herdentry2,IF(E64=\"Units\",F64/R64/Herdentry2,'3. DDD DCD'!G64/'3. DDD DCD'!R64))))","v":""},"","",null,null,null,null,null,"","",""]
[{"$f":"IF('2. Basic calculator'!A57=\"\",\"\",'2. Basic calculator'!A57)","v":""},{"$f":"IF('2. Basic calculator'!B57=\"\",\"\",'2. Basic calculator'!B57)","v":""},null,{"$f":"IF('2. Basic calculator'!C57=\"\",\"\",'2. Basic calculator'!C57)","v":""},{"$f":"IF('2. Basic calculator'!D57=\"\",\"\",'2. Basic calculator'!D57)","v":""},"",{"$f":"IF('2. Basic calculator'!E57=\"\",\"\",'2. Basic calculator'!E57)","v":""},{"$f":"IF(A65=\"\",\"\",IF(A65=\"Footbath\",F65/Q65/Herdentry2,IF(E65=\"Tubes\",D65/Q65/Herdentry2,IF(E65=\"Units\",F65/Q65/Herdentry2,'3. DDD DCD'!G65/'3. DDD DCD'!Q65))))","v":""},{"$f":"IF(A65=\"\",\"\",IF(A65=\"Footbath\",F65/R65/Herdentry2,IF(E65=\"Tubes\",D65/R65/Herdentry2,IF(E65=\"Units\",F65/R65/Herdentry2,'3. DDD DCD'!G65/'3. DDD DCD'!R65))))","v":""},"","",null,null,null,null,null,"","",{"$f":"IF(E65=\"\",\"\",IF(E65=\"ml\",\"kg\",IF(E65=\"grams\",\"kg\",\"unit\")))","v":""}]
[]
[]
[]
[]
[null,null,"DDD/PCU",null,"DDDcritical",null,"DCD/PCU","DCD/cow","DCDcritical"]
["Injectable","mg/kg",{"$f":"SUMIF($A$15:$A$65,$A71,H$15:H$65)","v":2.3905144387072093E-3},null,{"$f":"SUMIFS($H$15:$H$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A71)","v":0},null,{"$f":"SUMIF($A$15:$A$65,$A71,I$15:I$65)","v":6.8418171866447728E-4},null,{"$f":"SUMIFS($I$15:$I$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A71)","v":0}]
["Oral","DDD/DCD/kg",0,null,0,null,0,null,{"$f":"SUMIFS($I$15:$I$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A72)","v":0}]
["Topical","DDD/DCD/ewe",0,null,0,null,0,null,0]
["Footbath","DDD/DCD/ewe",0,null,0,null,0,null,0]
["EyeTreatment","DDD/DCD/ewe",0,null,0,null,0,null,{"$f":"SUMIFS($I$15:$I$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A75)","v":0}]
["Intramammary","DDD/DCD/ewe",0,null,0,null,0,null,{"$f":"SUMIFS($I$15:$I$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A76)","v":0}]
[]
[null,null,null,"Critically important"]
["Injectable","Injectable",{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"\",$A$15:$A$65,$A79)","v":1.984126984126984E-2},{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A79)","v":0}]
["Oral","Oral",{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"\",$A$15:$A$65,$A80)","v":0},{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A80)","v":0}]
["Topical","Topical",0,{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A81)","v":0}]
["Footbath","Footbath",0,0]
["EyeTreatment","Eye",{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"\",$A$15:$A$65,$A83)","v":0},0]
["Intramammary","Intramammary",{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"\",$A$15:$A$65,$A84)","v":0},{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A84)","v":0}]

{"sheet":"4. Instructions","index":3,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,0,11,1],[12,0,12,1]]}
["University of Nottingham Sheep Antimicrobial Use Calculator 3.5"]
["Disclaimer: Please note, use of this calculator is at the user's own risk "]
[]
["Instructions"]
["This calculator is designed to provide an estimation of antimicrobial usage on farms using Sheep Health and "]
["Welfare Group (SHAWG) core sheep antibiotic metrics. Further guidance is available here."]
["The calculator incorporates core sheep metrics with ESVAC methodology such as DDD and DCD. "]
["There are various caveats to each method, and these should be discussed with your veterinarian. "]
[]
["       Mg/kg describes the SHAWG core sheep metric and is calculated as follows: "]
[]
["Total mass antibiotic (mg)"]
["[20 x total numbers of lambs (finished+store)] + [75 x number of ewes] (kg)"]
[]
["       DDD describes the number of equivalent doses of antibiotic per animal or Kg on a farm"]
["       DCD describes the number of equivalent courses of an antibiotic per animal or Kg on a farm"]
["Enter farm details by clicking: "]
["Enter all antimicrobials used on the farm over a twelve month period"]
["Select a ROUTE, PRODUCT and AMOUNT of drug used by clicking: "]
["Amount used will be presented in mls, grams or units"]
["To delete products, highlight ROUTE, PRODUCT and AMOUNT for each row and press delete"]
["Further information including daily dose and course dose information is found on the DDD/DCD calculator"]
[]
["Defined daily dose (DDD) and Defined course dose (DCD) is reported as follows:"]
[null,"DDD","DCD"]
["Injectable/oral products","Doses/Kg","Courses/Kg"]
["Topical products*","Doses/Ewe","Courses/Ewe"]
["Antibiotics used in footbaths**","Doses/Ewe","Courses/Ewe"]
["Eye treatment***","Doses/Ewe","Courses/Ewe"]
["Intramammary","Doses/Ewe","Courses/Ewe"]
["*For the purposes of this calculator DDD/DCD calculations for footbaths have been based on 100g antibiotic powder per footbath to treat 100 adult sheep"]
["** For the purposes of this calculator DDD/DCD calculations for footbaths have been based on one 3-5s spray per ewe being a dose"]
["*** For the purposes of this calculator DDD/DCD calculations for eye treatments have been based on one 1/4 tube application per ewe being a dose"]
[]
["SHAWG core metric standard weights"]
["Animal","Weight (kg)"]
["Ewes on farm",75]
["Lamb (stores or for breeding)",20]
["Lambs finished",20]

{"sheet":"Sheet 5","index":4,"n_rows":138,"n_cols":13,"rows_kept":138,"cut":false,"hidden":false,"merged":[]}
["Drug","Active","Route","Dose mg/kg (or mg/tube)","treatments (days/tubes)","Dose per Tx","Critical","mg/unit","Units","DDD","DCD",null,"Route"]
["Erythrocin 16.5 % w/w Soluble Powder for oral solution","Erythromycin","Footbath",165000,null,{"$f":"D2","v":165000},0,165,"grams",165,165,null,"Injectable"]
["Lincocin soluble powder for oral solution","Lincomycin","Footbath",60000,null,{"$f":"D3","v":60000},0,400,"grams",400,400,null,"Oral"]
["Linco-Spectin 100, 222/444.7 mg/g Powder for use in drinking water for pigs & chickens","Lincomycin","Footbath",64470.000000000007,1,{"$f":"D4","v":64470.000000000007},0,644.70000000000005,"grams",{"$f":"H4","v":644.70000000000005},{"$f":"H4","v":644.70000000000005},null,"Topical"]
["Tylan Soluble Powder for Oral Solution Footbath","Tylosin","Footbath",100000,1,{"$f":"D5","v":100000},0,1000,"grams",{"$f":"H5","v":1000},{"$f":"H5","v":1000},null,"Footbath"]
["Advocin 180 mg/ml Solution for Injection for Cattle","Danofloxacin Mesylate","Injectable",6,2,2550,1,180,"ml",1.9,5.0999999999999996,null,"EyeTreatment"]
["Advocin 2.5% Solution for Injection","Danofloxacin Mesylate","Injectable",1.25,3,531.25,1,25,"ml",1.9,5.0999999999999996,null,"Intramammary"]
["Alamycin 100mg/ml Solution for Injection","Oxytetracycline","Injectable",4,3,1700,0,100,"ml",6.5,23]
["Alamycin LA 200mg/ml Solution for Injection","Oxytetracycline","Injectable",20,1,8500,0,200,"ml",6.5,23]
["Alamycin LA 300 Solution for Injection 300mg/ml","Oxytetracycline","Injectable",20,1,8500,0,300,"ml",6.5,23]
["Amfipen LA 100 mg/ml suspension for injection","Ampicillin","Injectable",15,2,6375,0,100,"ml",8.3000000000000007,29]
["Amoxycare LA Suspension for Injection 15% w/v ","Amoxicillin","Injectable",15,null,null,0,150,"ml",8.3000000000000007,29]
["Amoxypen Injection 150 mg/ml Suspension for injection","Amoxicillin Trihydrate","Injectable",7,5,2975,0,150,"ml",8.3000000000000007,29]
["Amoxypen LA 150 mg/ml Suspension for injection","Amoxicillin Trihydrate","Injectable",15,2,6375,0,150,"ml",8.3000000000000007,29]
["Apotil 300 mg/ml Solution for Injection","Tilmicosin","Injectable",10,1,4250,0,300,"ml",4,9.8000000000000007]
["Baytril 100 mg/ml","Enrofloxacin","Injectable",5,5,2125,1,100,"ml",4.2,16]
["Baytril 50 mg/ml","Enrofloxacin","Injectable",5,5,2125,1,50,"ml",4.2,16]
["Baytril Max 100 mg/ml","Enrofloxacin","Injectable",7.5,1,3187.5,1,100,"ml",4.2,16]
["Betamox 150mg/ml Suspension for Injection","Amoxicillin","Injectable",7,5,2975,0,150,"ml",8.3000000000000007,29]
["Betamox LA 150mg/ml Suspension for Injection","Amoxicillin","Injectable",15,2,6375,0,150,"ml",8.3000000000000007,29]
["Bimotrim Co Injection","Sulfadoxine","Injectable",15,5,6375,0,240,"ml",14,51]
["Bimoxyl LA 150 mg/ml","Amoxicillin ","Injectable",15,2,6375,0,150,"ml",8.3000000000000007,29]
["Cefenil Powder and Solvent Solution for Injection","Ceftiofu","Injectable",1,5,425,1,50,"ml",1,4]
["Cefenil RTU 50mg/ml Suspension for Injection","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Ceffect 25 mg/ml","Cefquinome","Injectable",1,5,425,1,25,"ml",1.5,5.5]
["Cefokel 50 mg/ml, Suspension for Injection for Pigs and Cattle","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Ceftiocyl 50mg/ml suspension for injection for cattle and pigs","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Cemay 50 mg/ml","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Ceporex 180 mg/ml Suspension for injection for cattle, cats and dogs","Sodium Cefalexin","Injectable",7,5,2975,0,180,"ml",7,32]
["Cevaxel RTU 50 mg/ml","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Clamoxyl Ready-to-Use 150 mg/ml suspension for injection","Amoxicillin Trihydrate","Injectable",7,5,2975,0,150,"ml",8.3000000000000007,29]
["Cobactan 2.5% Injection","Cefquinome ","Injectable",null,null,null,1,25,"ml",1.5,5.5]
["Cobactan 4.5 % Powder and solvent for solution for injection for horse and cattle","Cefquinome","Injectable",1,5,425,1,45,"ml",1.5,5.5]
["Combiclav Suspension for Injection","Amoxicillin","Injectable",8.75,5,3718.75,0,140,"ml",8.3000000000000007,29]
["Curacef Duo suspension for injection for cattle","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Cyclosol® LA 200 mg/ml Solution for Injection","Oxytetracycline","Injectable",20,1,8500,0,200,"ml",6.5,23]
["Depocillin 300 mg/ml Suspension for injection","Procaine Benzylpenicillin","Injectable",30,5,12750,0,300,"ml",13,46]
["Devomycin 250mg/ml Solution for Injection","Streptomycin Sulphate","Injectable",10,3,4250,0,250,"ml",28,85]
["Draxxin 100 mg/ml solution for injection for cattle & pigs","Tulathromycin","Injectable",2.5,1,1062.5,0,100,"ml",0.3,2.5]
["Duphamox 150 mg/ml Suspension for Injection","Amoxicillin Trihydrate","Injectable",7,5,2975,0,150,"ml",8.3000000000000007,29]
["Duphapen Fort 300 mg/ml Suspension for Injection","Procaine Penicillin","Injectable",20,null,null,0,30,"ml",13,46]
["Duphapen + Strep Procaine Penicillin 200 mg & Dihydrostreptomycin Sulphate 250 mg Suspension for Injection","Procaine Penicillin","Injectable",18,null,null,0,372,"ml",13,46]
["Duphatrim IS Injectable Solution","Sulfadiazine","Injectable",15,5,6375,0,240,"ml",13,36]
["Eficur","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Engemycin 10 % (DD) Solution for injection","Oxytetracycline Hydrochloride","Injectable",10,5,4250,0,100,"ml",6.5,23]
["Engemycin LA 200 mg/ml Solution for injection","Oxytetracycline Dihydrate","Injectable",20,1,8500,0,200,"ml",6.5,23]
["Enroxil® 100 mg/ml Solution for Injection for Cattle and Pigs","Enrofloxacin","Injectable",5,5,2125,1,100,"ml",4.2,16]
["Excenel 50 mg/ml Sterile Powder for Solution for Injection\n ","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Excenel Flow 50 mg/ml Suspension for Injection for Pigs & Cattle","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Fenflor® 300 mg/ml Solution for Injection for Cattle","Florfenicol","Injectable",40,1,17000,0,300,"ml",13,40]
["Fenoflox 100mg/ml Solution for Injection for Cattle and Pigs\n ","Enrofloxacin","Injectable",5,5,2125,1,100,"ml",4.2,16]
["Fenoflox 50mg/ml Solution for Injection for Cattle, Pigs, Dogs and Cats\n ","Enrofloxacin","Injectable",5,5,2125,1,50,"ml",4.2,16]
["Florkem 300 mg/ml ","Florfenicol","Injectable",20,2,8500,0,300,"ml",13,40]
["Forcyl 160 ml/ml Solution for Injection for Cattle","Marbofloxacin","Injectable",10,1,4250,1,160,"ml",3.6,8.9]
["Framomycin 150 mg/ml Solution for Injection","Framycetin Sulfate","Injectable",5,3,2125,0,150,"ml",5,10]
["Hexasol LA Solution for Injection for Cattle","Oxytetracycline","Injectable",null,null,null,0,300,"ml",6.5,23]
["Hymatil 300 mg/ml solution for injection for cattle and sheep.","Tilmicosin","Injectable",10,null,null,0,300,"ml",4,9.8000000000000007]
["Intradine","Sulphadimidine","Injectable",200,3,85000,0,308.89999999999998,"ml",16,65]
["Kefloril 300mg/ml Solution for injection for cattle and pigs","Florfenicol","Injectable",40,1,17000,0,300,"ml",13,40]
["Intradine 30.89% w/v Solution for Injection  \n\n","Sulfadimidine","Injectable",200,null,null,0,308.89999999999998,"ml",13,36]
["Kelacyl 100 mg/ml, Solution for Injection for Cattle and Pigs","Marbofloxacin","Injectable",2,5,850,1,100,"ml",3.6,8.9]
["Mamyzin 269.5 mg/ml ","Penethamate hydriodide","Injectable",15,4,6375,0,169.785,"ml",12,38]
["Marbocyl™ 10% Solution for Injection","Marbofloxacin","Injectable",2,5,850,1,100,"ml",3.6,8.9]
["Marbocyl™ 2% Solution for Injection","Marbofloxacin","Injectable",2,5,850,1,20,"ml",3.6,8.9]
["Marbonor 100mg/ml Solution for Injection for Cattle and Pigs","Marbofloxacin","Injectable",2,5,850,1,100,"ml",3.6,8.9]
["Marbonor SOLO 100mg/ml Solution for Injection for Cattle","Marbofloxacin","Injectable",8,1,3400,1,100,"ml",3.6,8.9]
["Marbox 100 mg/ml ","Marbofloxacin","Injectable",8,1,3400,1,100,"ml",3.6,8.9]
["Micotil 300mg/ml Solution for Injection\n","Tilmicosin","Injectable",10,1,4250,0,300,"ml",4,9.8000000000000007]
["Milbotyl 300mg/ml Solution for Injection","Tilmicosin","Injectable",10,1,4250,0,300,"ml",4,9.8000000000000007]
["Naxcel 200 mg/ml Suspension for Injection for Cattle","Ceftiofur","Injectable",6.6,1,2805,1,200,"ml",1,4]
["Norfenicol 300mg/ml Solution for Injection for Cattle and Swine","Florfenico","Injectable",20,2,8500,0,300,"ml",13,40]
["Norobrittin 15% w/v Suspension for Injection","Ampicillin","Injectable",7.5,5,3187.5,0,150,"ml",8.3000000000000007,29]
["Norocillin Injection","Penicillin G","Injectable",null,null,null,null,300,"ml",13,46]
["Noroclav Injection","Amoxicillin","Injectable",8.75,5,3718.75,0,140,"ml",8.3000000000000007,29]
["Norodine 24 Solution for Injection","Trimethoprim","Injectable",15,5,6375,0,240,"ml",13,36]
["Norotril Max 100mg/ml Solution for Injection","Enrofloxacin","Injectable",7.5,1,3187.5,1,100,"ml",4.2,16]
["Nuflor 300 mg/ml solution for injection for cattle and sheep","Florfenicol","Injectable",40,1,17000,0,300,"ml",13,40]
["Nuflor Minidose 450 mg/ml solution for injection for cattle","Florfenicol","Injectable",40,1,17000,0,450,"ml",13,40]
["Pen & Strep Suspension For Injection","Procaine Penicillin","Injectable",18,3,7650,0,372,"ml",13,46]
["Permacyl","Penethamate Hydriodide","Injectable",14.2,4,6035,0,236.3,"ml",12,38]
["Pharmasin 200mg/ml solution for injection for cattle and pigs.","Tylosin","Injectable",10,3,4250,0,200,"ml",13,59]
["Readycef 50mg/mL suspension for injection for swine and cattle","Ceftiofur","Injectable",1,5,425,1,50,"ml",1,4]
["Resflor 300/16.5 mg/ml Solution for Injection for Cattle","Florfenicol","Injectable",40,1,17000,0,300,"ml",13,40]
["Selectan","Florfenicol\n","Injectable",20,2,8500,0,300,"ml",13,40]
["Shotaflor 300mg/mL Solution for Injection for Cattle","Florfenicol","Injectable",40,1,17000,0,300,"ml",13,40]
["Spectam injectable 10%","Spectinomycin","Injectable",30,5,12750,0,100,"ml",28,85]
["Synulox Ready-To-Use Suspension for Injection","Amoxicillin Trihydrate","Injectable",7,5,2975,0,140,"ml",8.3000000000000007,29]
["Terramycin/LA 200 mg/ml Solution for Injection","Oxytetracycline Hydrochloride","Injectable",20,1,8500,0,200,"ml",6.5,23]
["Tetroxy Vet 200mg/ml","Oxytetracycline","Injectable",20,1,8500,0,200,"ml",6.5,23]
["Tribrissen 48 % suspension for injection","Sulfadiazine","Injectable",15,5,6375,0,480,"ml",13,36]
["Tylan 200, 200mg/ml Solution for Injection","Tylosin Phosphate","Injectable",10,3,4250,0,200,"ml",13,59]
["Ultrapen LA 30% Suspension for Injection","Procaine Benzyl Penicillin","Injectable",20,1,8500,0,183,"ml",13,46]
["Vetrimoxin L.A. 150mg/ml suspension for injection for cattle and pigs","Amoxicillin Trihydrate","Injectable",15,2,6375,0,150,"ml",8.3000000000000007,29]
["Zactran 150mg/ml solution for injection for cattle and pigs","Gamithromycin","Injectable",6,1,2550,0,150,"ml",6,6]
["Zuprevo 180 mg/ml solution for injection for cattle","Tildipirosin","Injectable",4,1,1700,0,180,"ml",4,4]
["Apralan Soluble Powder for Oral Solution","Apramycin Sulfate","Oral",40,5,5600,0,1000,"grams",30,150]
["Coliplus 2,000,000 IU/ml ","Colistin ","Oral",4.1665000000000001,5,583.31000000000006,1,98,"ml",4.8,24]
["Doxx-Sol 500mg/g powder for use in drinking water/milk replacer for pre-ruminant calves, pigs and chickens\n","Doxycycline Hyclate","Oral",10,10,1400,0,500,"grams",10,42]
["Baytril 2.5% Oral Solution","Enrofloxacin","Oral",2.5,3,350,1,25,"ml",4.7,22]
["Bimamix Oral Suspension","Neomycin","Oral",70,10,9800,0,175,"ml",21,85]
["Orojet Lamb Oral Solution","Neomycin","Oral",null,null,null,0,140,"ml",21,85]
["Parofor 70mg/g powder for use in drinking water, milk or milk replacer for pre-ruminant cattle and pigs","Paromomycin sulphate","Oral",50,5,7000,0,70,"grams",38,150]
["Pulmotil AC","Tilmicosin","Oral",12.5,5,1750,0,250,"ml",21,85]
["Tilmovet 250mg/ml Concentrate for Oral Solution","Tilmicosin","Oral",12.5,10,1750,0,250,"ml",21,85]
["Tylan Soluble Powder for Oral Solution","Tylosin Tartrate","Oral",1000,28,{"$f":"D105","v":1000},0,1000,"grams",41,414]
["Synulox Bolus 500 mg film-coated tablet","Amoxicillin Trihydrate","Oral",12.5,6,1750,0,400,"Units",20,81]
["Marbocyl™ Bolus 50 mg Tablet","Marbofloxacin","Oral",1,3,140,1,50,"Units",1,3]
["Occrycetin Bolus 500mg Tablet","Oxytetracycline Hydrochloride","Oral",10,10,1400,0,500,"Units",20,111]
["Strinacin II Tablets","Sulfadiazine","Oral",30,5,4200,0,1200,"Units",24,114]
["Norodine Bolus Tablets","Trimethoprim","Oral",30,5,4200,0,1200,"Units",4.8,23]
["Spectam Scour Halt oral solution 50 mg/ml","Spectinomycin","Oral",50,"ml",0,null,50,"ml",28,85]
["Strinacin II Tablets","Sulfadiazine","Oral",1200,"Units",0,null,200,"Units",13,36]
["Synulox Bolus 500 mg film-coated tablet","Amoxicillin Trihydrate","Oral",500,"Units",0,null,400,"Units",8.3000000000000007,29]
["Tilmovet 250mg/ml Concentrate for Oral Solution","Tilmicosin","Oral",250,"ml",0,null,250,"ml",4,9.8000000000000007]
["Tribrissen 20 Tablets","Trimethoprim","Oral",100,"units",null,0,100,"Units",4.8,23]
["Alamycin aerosol 140g","Oxytetracycline","Topical",null,null,null,0,5000,"Units",150,450]
["Cyclo Spray® 422ml, Chlortetracycline HCL 2.45% w/w Cutaneous Spray, Suspension for Pigs, Sheep and Cattle ","Chlortetracycline","Topical",null,null,null,0,10339,"Units",103.39,310.17]
["Engemycin Spray 25 mg/ml 200ml cutaneous spray, suspension for cattle, sheep and pigs","Oxytetracycline","Topical",null,null,null,0,5000,"Units",100,300]
["TAF Spray® 28.5 mg/g Cutaneous Spray, Solution","Thiamphenicol","Topical",null,null,null,0,4275,"Units",42.75,128.25,"TAF 3-5s spray= similar amount of product as oxytet sprays, so have extrapolated. 3-5s spray=4g of product"]
["Terramycin Aerosol Spray 3.92% w/w 150ml cutaneous spray","Oxytetracycline","Topical",null,null,null,0,4000,"Units",120,360]
["Opticlox Eye Ointment 16.7% w/w","Cloxacillin","Eye treatment",null,null,null,0,835,"Units",125.25,250.5,"Orbenin opthalmic states 1/4 tube (equivalent to 125mg) so extrapolated"]
["Orbenin Ophthalmic Eye Ointment 16.67% w/w","Cloxacillin","Eye treatment",null,null,null,0,500,"Units",125,250,"Use a 1/4 tube per eye, can repeat once"]
["Ceffect LC, 75mg, Intramammary Ointment for Lactating Cows","Cefquinome","IMM",75,3,75,1,75,"Tubes",1,3]
["Cefimam LC, 75mg Intramammary Ointment for Lactating Cows","Cefquinome","IMM",75,3,75,1,75,"Tubes",1,3]
["Cobactan MC Intramammary suspension 75 mg Milking cow","Cefquinome","IMM",75,3,75,1,75,"Tubes",1,3]
["Combiclav Lactating Cow Intramammary Suspension","Amoxicillin","IMM",200,3,200,0,200,"Tubes",1,3]
["Duofast Intramammary Suspension","Trimethoprim","IMM",240,3,240,0,240,"Tubes",1,3]
["Lactaclox Intramammary Infusion","Cloxacillin","IMM",275,3,275,0,275,"Tubes",1,3]
["Lincocin Forte S Intramammary Solution","Lincomycin","IMM",430,3,430,0,430,"Tubes",1,3]
["Mastiplan LC 300mg/20mg (Cefapirin/Prednisolone), intramammary suspension for lactating cows","Cephapirin","IMM",300,4,300,0,300,"Tubes",1,3]
["Multiject IMM Intramammary Suspension","Procaine Penicillin","IMM",300,3,300,0,261,"Tubes",1,3]
["Noroclav Lactating Cow Intramammary Suspension","Amoxicillin","IMM",200,3,200,0,200,"Tubes",1,3]
["Orbenin L.A. 200 mg Intramammary Suspension","Cloxacillin Sodium","IMM",200,3,200,0,200,"Tubes",1,3]
["Pathocef 250 mg Intramammary Suspension","Cefoperazone","IMM",250,1,250,1,250,"Tubes",1,3]
["Synulox Lactating Cow Intramammary Suspension","Amoxicillin Trihydrate","IMM",200,3,200,0,200,"Tubes",1,3]
["Tetra-Delta Intramammary Suspension","Dihydrostreptomycin","IMM",405,2,405,0,366,"Tubes",1,3]
["Ubro Yellow Milking Cow Intramammary Suspension","Dihydrostreptomycin","IMM",294.5,3,294.5,0,294.5,"Tubes",1,3]
["Ubrolexin Intramammary ","Cefalexin","IMM",200,2,200,0,325.6281407035176,"Tubes",1,3]